package com.cn.jdia.di.constans;

public class SqlConstans {

	public static final String dhCount = "select count(*) from QDJC_ODS.TB_AVIATION_DH_FOD where PDATE=to_char(sysdate,'YYYY-MM-dd')";

	public static final String shCount = "select count(*) from QDJC_ODS.TB_AVIATION_SH_FDNY where FLIGHT_DATE=to_char(sysdate,'YYYY-MM-dd')";

	public static final String qhCount = "select count(*)  from  QDJC_ODS.TB_AVIATION_QH_FDNY where FLIGHTDATE =to_char(sysdate,'YYYY-MM-dd')";

	public static final String aocCount = "select count(*) from AOC_DBO.DYNFLIGHT where to_char(EXECDATE,'YYYY-MM-dd') =to_char(sysdate,'YYYY-MM-dd')";

	public static final String kgCount = "select count(*) from QDJC_ODS.TB_KG_SAMEDAY WHERE SD_TIME like to_char(sysdate,'YYYYMMdd%')";

	public static final String insDel="delete from datainspect";
	
	public String dhIns="insert into datainspect value ('%src%',%count%,'%time%')";
}
